﻿CREATE PROCEDURE [dbo].[proc_Customer_RemindGetList]
	(
		@UserName nvarchar(50)
	)
AS
Begin
	Select	top 10 	Id,
	CustomerId,
	IsNull((Select CustomerName From Customer Where CustomerId=Customer_Remind.CustomerId And ProtectName=@UserName),'...') As CustomerName,
	RemindDate,
	UserName,
	UpTime From Customer_Remind
	where username=@username and Convert(varchar(10),UpTime,23)=Convert(varchar(10),GetDate(),23)
End